{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Tractors1","Tractors2","Machines","Machines2","Machines3","Machines4","Trailers","Result","Machine list","Guidance"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":8,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tractors1","index":0,"n_rows":100,"n_cols":9,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,1,0,3],[31,4,31,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[26,4,26,5],[25,4,25,5]]}
["Farm:",{"$f":"Result!F1","v":0},null,null,null,null,"Year:",{"$f":"Result!F4","v":2021}]
["Costs for tractors, combines and self-propelled sprayer"]
[null,null,null,null,null,null,null,"© kura & cha 07.01.22"]
["Make / model:"]
["Market value of the machine, Euro",null,null,null,null,null,null,null,{"$f":"SUM(B5:H5)","v":0}]
["Calculation period, years"]
["Annual loss of value,%"]
["Calculation rate %",{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0}]
["Scrap value at end of period, Euro",{"$f":"B5*(1-B7)^B6","v":0},{"$f":"C5*(1-C7)^C6","v":0},0,0,0,{"$f":"G5*(1-G7)^G6","v":0},0]
["Average capital costs, Euro / year",{"$f":"IF(AND(ISNUMBER(B5),ISNUMBER(B6),ISNUMBER(B7),ISNUMBER(B8)),PMT(B8,B6,B5,-B9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C5),ISNUMBER(C6),ISNUMBER(C7),ISNUMBER(C8)),PMT(C8,C6,C5,-C9)*-1,0)","v":0},0,0,0,{"$f":"IF(AND(ISNUMBER(G5),ISNUMBER(G6),ISNUMBER(G7),ISNUMBER(G8)),PMT(G8,G6,G5,-G9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(H5),ISNUMBER(H6),ISNUMBER(H7),ISNUMBER(H8)),PMT(H8,H6,H5,-H9)*-1,0)","v":0},{"$f":"SUM(B10:H10)","v":0}]
["Average insurances euro/ year",null,null,null,null,null,null,null,{"$f":"SUM(B11:H11)","v":0}]
["Various costs Euro / year",null,null,null,null,null,null,null,{"$f":"SUM(B12:H12)","v":0}]
["Capacity costs, Euro / year",{"$f":"SUM(B10:B12)","v":0},{"$f":"SUM(C10:C12)","v":0},0,0,0,{"$f":"SUM(G10:G12)","v":0},{"$f":"SUM(H10:H12)","v":0},{"$f":"SUM(B13:H13)","v":0}]
["Maintenance, Euro / hour"]
["Fuel, liters / hour"]
["Fuel, Euro / hour",{"$f":"B15*Result!$F$5","v":0},{"$f":"C15*Result!$F$5","v":0},{"$f":"D15*Result!$F$5","v":0},{"$f":"E15*Result!$F$5","v":0},{"$f":"F15*Result!$F$5","v":0},{"$f":"G15*Result!$F$5","v":0},{"$f":"H15*Result!$F$5","v":0}]
["Salary, Euro / hour"]
["Unit costs, Euro / hour",{"$f":"B14+B16+B17","v":0},0,{"$f":"D14+D16+D17","v":0},0,0,{"$f":"G14+G16+G17","v":0},0]
["Use, hours / year",null,null,null,null,null,{"$f":"IF(G23<>0,G24/G23,0)","v":0},{"$f":"IF(H23<>0,H24/H23,0)","v":0}]
["Distributed tractor hours, year",{"$f":"Machines!$L40+Machines2!$L40+Machines3!$L40+Machines4!$L40+Trailers!$L40","v":0},{"$f":"Machines!M40+Machines2!M40+Machines3!M40+Machines4!M40+Trailers!M40","v":0},{"$f":"Machines!N40+Machines2!N40+Machines3!N40+Machines4!N40+Trailers!N40","v":0},{"$f":"Machines!O40+Machines2!O40+Machines3!O40+Machines4!O40+Trailers!O40","v":0},{"$f":"Machines!P40+Machines2!P40+Machines3!P40+Machines4!P40+Trailers!P40","v":0}]
["Capacity costs, Euro / hour",{"$f":"IF(B19<>0,B13/B19,\"\")","v":""},{"$f":"IF(C19<>0,C13/C19,\"\")","v":""},{"$f":"IF(D19<>0,D13/D19,\"\")","v":""},{"$f":"IF(E19<>0,E13/E19,\"\")","v":""},{"$f":"IF(F19<>0,F13/F19,\"\")","v":""},{"$f":"IF(G19<>0,G13/G19,\"\")","v":""},""]
["Total cost, Euro / hour",{"$f":"IF(B19>0,B21+B18,0)","v":0},{"$f":"IF(C19>0,C21+C18,0)","v":0},{"$f":"IF(D19>0,D21+D18,0)","v":0},{"$f":"IF(E19>0,E21+E18,0)","v":0},{"$f":"IF(F19>0,F21+F18,0)","v":0},{"$f":"IF(G19>0,G21+G18,0)","v":0},0]
[null,null,null,null,"Capacity combine/sprayer ha / hour"]
[null,null,null,null,"Covered area, ha / year"]
[null,null,null,null,"Combine/sprayer Euro / ha",null,{"$f":"IF(G23<>0,G22/G23,0)","v":0},{"$f":"IF(H23<>0,H22/H23,0)","v":0}]
[null,null,null,null,"Machine station rate, Euro / ha"]
[null,null,null,null,"Result own machine, Euro./ha",null,{"$f":"G26-G25","v":0},{"$f":"H26-H25","v":0}]
[]
[]
[]
[]
[null,null,null,null,"Hourly consumption / assignment",null,{"$f":"G19","v":0},0]
[null,null,null,null,null,null,"Total hours / year =",{"$f":"SUM(B32:H32)","v":0},{"$f":"H33","v":0}]
[]
[]
["Vedligehold årligt, kr.",{"$f":"B$19*B14","v":0},{"$f":"C$19*C14","v":0},{"$f":"D$19*D14","v":0},{"$f":"E$19*E14","v":0},{"$f":"F$19*F14","v":0},{"$f":"G$19*G14","v":0},0,{"$f":"SUM(B36:H36)","v":0}]
["Brændstof årligt, kr.",{"$f":"B$19*B16","v":0},0,0,0,0,{"$f":"G$19*G16","v":0},0,0]
["Lønomkostning årligt, kr.",0,0,0,0,0,{"$f":"G$19*G17","v":0},0,{"$f":"SUM(B38:H38)","v":0}]
[]
[]
["Resultat egne maskiner",null,null,null,null,null,{"$f":"G27*G24","v":0},{"$f":"H27*H24","v":0},{"$f":"SUM(G41:H41)","v":0}]
["Ufordelte traktoromkostninger",{"$f":"(B19-B20)*-B22","v":0},{"$f":"(C19-C20)*-C22","v":0},0,0,0,null,null,{"$f":"SUM(B42:H42)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,123456789123,123456789123,123456789123,123456789123,123456789123,123456789123,123456789123]

{"sheet":"Tractors2","index":1,"n_rows":100,"n_cols":9,"rows_kept":100,"cut":false,"hidden":false,"merged":[[31,4,31,5],[0,1,0,3],[22,4,22,5],[23,4,23,5],[24,4,24,5],[25,4,25,5],[26,4,26,5]]}
["Farm:",{"$f":"Result!F1","v":0},null,null,null,null,"Year:",{"$f":"Result!F4","v":2021}]
["Costs for tractors, combines and self-propelled sprayer"]
[]
["Make / model:"]
["Market value of the machine, Euro",null,null,null,null,null,null,null,{"$f":"SUM(B5:H5)","v":0}]
["Calculation period, years"]
["Annual loss of value,%"]
["Calculation rate %",{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0}]
["Scrap value at end of period, Euro",{"$f":"B5*(1-B7)^B6","v":0},{"$f":"C5*(1-C7)^C6","v":0},0,0,0,0,0]
["Average capital costs, Euro / year",{"$f":"IF(AND(ISNUMBER(B5),ISNUMBER(B6),ISNUMBER(B7),ISNUMBER(B8)),PMT(B8,B6,B5,-B9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C5),ISNUMBER(C6),ISNUMBER(C7),ISNUMBER(C8)),PMT(C8,C6,C5,-C9)*-1,0)","v":0},0,0,0,0,0,{"$f":"SUM(B10:H10)","v":0}]
["Average insurances euro/ year",null,null,null,null,null,null,null,{"$f":"SUM(B11:H11)","v":0}]
["Various costs Euro / year",null,null,null,null,null,null,null,{"$f":"SUM(B12:H12)","v":0}]
["Capacity costs, Euro / year",{"$f":"SUM(B10:B12)","v":0},{"$f":"SUM(C10:C12)","v":0},0,0,0,0,0,{"$f":"SUM(B13:H13)","v":0}]
["Maintenance, Euro / hour"]
["Fuel, liters / hour"]
["Fuel, Euro / hour",{"$f":"B15*Result!$F$5","v":0},{"$f":"C15*Result!$F$5","v":0},{"$f":"D15*Result!$F$5","v":0},{"$f":"E15*Result!$F$5","v":0},{"$f":"F15*Result!$F$5","v":0},{"$f":"G15*Result!$F$5","v":0},{"$f":"H15*Result!$F$5","v":0}]
["Salary, Euro / hour"]
["Unit costs, Euro / hour",{"$f":"B14+B16+B17","v":0},0,0,0,0,0,0]
["Use, hours / year",null,null,null,null,null,{"$f":"IF(G23<>0,G24/G23,0)","v":0},{"$f":"IF(H23<>0,H24/H23,0)","v":0}]
["Distributed tractor hours, year",{"$f":"Machines!Q40+Machines2!Q40+Machines3!Q40+Machines4!Q40+Trailers!Q40","v":0},{"$f":"Machines!R40+Machines2!R40+Machines3!R40+Machines4!R40+Trailers!R40","v":0},{"$f":"Machines!S40+Machines2!S40+Machines3!S40+Machines4!S40+Trailers!S40","v":0},{"$f":"Machines!T40+Machines2!T40+Machines3!T40+Machines4!T40+Trailers!T40","v":0},{"$f":"Machines!U40+Machines2!U40+Machines3!U40+Machines4!U40+Trailers!U40","v":0}]
["Capacity costs, Euro / hour",{"$f":"IF(B19<>0,B13/B19,\"\")","v":""},{"$f":"IF(C19<>0,C13/C19,\"\")","v":""},{"$f":"IF(D19<>0,D13/D19,\"\")","v":""},{"$f":"IF(E19<>0,E13/E19,\"\")","v":""},{"$f":"IF(F19<>0,F13/F19,\"\")","v":""},{"$f":"IF(G19<>0,G13/G19,\"\")","v":""},""]
["Total cost, Euro / hour",{"$f":"IF(B19>0,B21+B18,0)","v":0},{"$f":"IF(C19>0,C21+C18,0)","v":0},{"$f":"IF(D19>0,D21+D18,0)","v":0},{"$f":"IF(E19>0,E21+E18,0)","v":0},{"$f":"IF(F19>0,F21+F18,0)","v":0},{"$f":"IF(G19>0,G21+G18,0)","v":0},0]
[null,null,null,null,"Capacity combine/sprayer ha / hour"]
[null,null,null,null,"Covered area, ha / year"]
[null,null,null,null,"Combine/sprayer Euro / ha",null,{"$f":"IF(G23<>0,G22/G23,0)","v":0},{"$f":"IF(H23<>0,H22/H23,0)","v":0}]
[null,null,null,null,"Machine station rate, Euro / ha"]
[null,null,null,null,"Result own machine, Euro./ha",null,{"$f":"G26-G25","v":0},{"$f":"H26-H25","v":0}]
[]
[]
[]
[]
[null,null,null,null,"Hourly consumption / assignment",null,{"$f":"G19","v":0},0]
[null,null,null,null,null,null,"Total hours / year =",{"$f":"SUM(B32:H32)","v":0},{"$f":"H33","v":0}]
[]
[]
["Vedligehold årligt, kr.",{"$f":"B$19*B14","v":0},{"$f":"C$19*C14","v":0},{"$f":"D$19*D14","v":0},{"$f":"E$19*E14","v":0},{"$f":"F$19*F14","v":0},{"$f":"G$19*G14","v":0},0,{"$f":"SUM(B36:H36)","v":0}]
["Brændstof årligt, kr.",{"$f":"B$19*B16","v":0},0,0,0,0,0,0,0]
["Lønomkostning årligt, kr.",0,0,0,0,0,0,0,{"$f":"SUM(B38:H38)","v":0}]
[]
[]
["Resultat egne maskiner",null,null,null,null,null,{"$f":"G27*G24","v":0},{"$f":"H27*H24","v":0},{"$f":"SUM(G41:H41)","v":0}]
["Ufordelte traktoromkostninger",{"$f":"(B19-B20)*-B22","v":0},{"$f":"(C19-C20)*-C22","v":0},0,0,0,null,null,{"$f":"SUM(B42:H42)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,123456789123,123456789123,123456789123,123456789123,123456789123,123456789123,123456789123]

{"sheet":"Machines","index":2,"n_rows":101,"n_cols":21,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
["Farm:",{"$f":"Result!F1","v":0},null,null,null,null,"Year:",{"$f":"Result!F4","v":2021}]
["Costs for field work"]
[]
["Make / model:"]
["Market value of the machine, Euro",null,null,null,null,null,null,null,{"$f":"SUM(B5:H5)","v":0}]
["Calculation period, years",null,null,null,null,null,null,null,null,1,{"$f":"Tractors1!B4","v":0},{"$f":"TRUNC(Tractors1!B22,0)","v":0}]
["Annual loss of value,%",null,null,null,null,null,null,null,null,2,{"$f":"Tractors1!C4","v":0},{"$f":"TRUNC(Tractors1!C22,0)","v":0}]
["Calculation rate %",{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},null,3,{"$f":"Tractors1!D4","v":0},{"$f":"TRUNC(Tractors1!D22,0)","v":0}]
["Scrap value at end of period, Euro",{"$f":"B5*(1-B7)^B6","v":0},{"$f":"C5*(1-C7)^C6","v":0},0,0,0,{"$f":"G5*(1-G7)^G6","v":0},0,null,4,{"$f":"Tractors1!E4","v":0},{"$f":"TRUNC(Tractors1!E22,0)","v":0}]
["Average capital costs, Euro / year",{"$f":"IF(AND(ISNUMBER(B5),ISNUMBER(B6),ISNUMBER(B7),ISNUMBER(B8)),PMT(B8,B6,B5,-B9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C5),ISNUMBER(C6),ISNUMBER(C7),ISNUMBER(C8)),PMT(C8,C6,C5,-C9)*-1,0)","v":0},0,0,0,{"$f":"IF(AND(ISNUMBER(G5),ISNUMBER(G6),ISNUMBER(G7),ISNUMBER(G8)),PMT(G8,G6,G5,-G9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(H5),ISNUMBER(H6),ISNUMBER(H7),ISNUMBER(H8)),PMT(H8,H6,H5,-H9)*-1,0)","v":0},{"$f":"SUM(B10:H10)","v":0},5,{"$f":"Tractors1!F4","v":0},{"$f":"TRUNC(Tractors1!F22,0)","v":0}]
["Average insurances euro/ year",null,null,null,null,null,null,null,{"$f":"SUM(B11:H11)","v":0},6,{"$f":"Tractors2!B4","v":0},{"$f":"TRUNC(Tractors2!B$22,0)","v":0}]
["Various costs Euro / year",null,null,null,null,null,null,null,{"$f":"SUM(B12:H12)","v":0},7,{"$f":"Tractors2!C4","v":0},{"$f":"TRUNC(Tractors2!C$22,0)","v":0}]
["Capacity costs, Euro / year",{"$f":"SUM(B10:B12)","v":0},{"$f":"SUM(C10:C12)","v":0},0,0,0,{"$f":"SUM(G10:G12)","v":0},{"$f":"SUM(H10:H12)","v":0},{"$f":"SUM(B13:H13)","v":0},8,{"$f":"Tractors2!D4","v":0},{"$f":"TRUNC(Tractors2!C$22,0)","v":0}]
["Maintenance, Euro / hour",null,null,null,null,null,null,null,null,9,{"$f":"Tractors2!E4","v":0},{"$f":"TRUNC(Tractors2!E$22,0)","v":0}]
["Tractor selection",null,null,null,null,null,null,null,null,10,{"$f":"Tractors2!F4","v":0},{"$f":"TRUNC(Tractors2!F$22,0)","v":0}]
["Tractor cost, Euro / hour",{"$f":"VLOOKUP(L22,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L23,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L24,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L25,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L26,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L27,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L28,$J$6:$L$16,3)","v":0},null,11,"(ingen traktor)",{"$f":"TRUNC(Tractors2!G$22,0)","v":0}]
["Unit costs, Euro / hour",{"$f":"B14+B16","v":0},{"$f":"C14+C16","v":0},0,0,0,0,0]
["Treated area, ha / year"]
["Capacity, ha / hour"]
["Hourly consump. / task, hours / year",{"$f":"IF(B19<>0,B18/B19,0)","v":0},{"$f":"IF(C19<>0,C18/C19,0)","v":0},0,0,0,0,0,null,null,null,"Database"]
["Capacity costs, Euro / hour",{"$f":"IF(SUM(B18:B19)=0,0,B13/B20)","v":0},{"$f":"IF(SUM(C18:C19)=0,0,C13/C20)","v":0},0,0,0,0,0,null,null,null,"Traktor","Timer"]
["Total cost, Euro / hour",{"$f":"B17+B21","v":0},{"$f":"C17+C21","v":0},0,0,0,0,0,null,null,null,11,{"$f":"B30","v":0}]
["Stykomkostninger, kr./ha",{"$f":"B17/B19","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,11,{"$f":"C30","v":0}]
["Total cost, Euro / ha",{"$f":"IF(B19<>0,B22/B19,0)","v":0},{"$f":"IF(C19<>0,C22/C19,0)","v":0},0,0,0,0,0,null,null,null,11,{"$f":"D30","v":0}]
["Machine station rate, Euro / ha",null,null,null,null,null,null,null,null,null,null,11,{"$f":"E30","v":0}]
["Result own machine, Euro./ha",{"$f":"B25-B24","v":0},{"$f":"C25-C24","v":0},0,0,0,0,0,null,null,null,11,{"$f":"F30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"G30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"H30","v":0}]
[]
["Hourly consumption / work assignment",{"$f":"IF(B20<>0,B20,0)","v":0},0,0,0,0,0,{"$f":"IF(H20<>0,H20,0)","v":0}]
[null,null,null,null,null,null,"Total hours/year =",{"$f":"SUM(B30:H30)","v":0},{"$f":"H31","v":0}]
[]
[]
["Vedligehold årligt, kr.",{"$f":"B14*B30","v":0},{"$f":"C14*C30","v":0},0,0,0,0,0,{"$f":"SUM(B34:H34)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Kriterie","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor"]
[null,null,null,null,null,null,null,null,null,null,"Traktor",1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,"Sumtimer",{"$f":"DSUM($L$21:$M$28,\"Timer\",L38:L39)","v":0},{"$f":"DSUM($L$21:$M$28,\"Timer\",M38:M39)","v":0},{"$f":"DSUM($L$21:$M$28,\"Timer\",N38:N39)","v":0},{"$f":"DSUM($L$21:$M$28,\"Timer\",O38:O39)","v":0},{"$f":"DSUM($L$21:$M$28,\"Timer\",P38:P39)","v":0},{"$f":"DSUM($L$21:$M$28,\"Timer\",Q38:Q39)","v":0},0,0,0,0]
[]
[]
["Resultat egne maskiner",{"$f":"B26*B18","v":0},0,0,0,0,0,0,{"$f":"SUM(B43:H43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,123456789123,123456789123,123456789123,123456789123,123456789123,123456789123,123456789123]

{"sheet":"Machines2","index":3,"n_rows":101,"n_cols":21,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
["Farm:",{"$f":"Result!F1","v":0},null,null,null,null,"Year: ",{"$f":"Result!F4","v":2021}]
["Costs for field work"]
[]
["Make / model:"]
["Market value of the machine, Euro",null,null,null,null,null,null,null,{"$f":"SUM(B5:H5)","v":0}]
["Calculation period, years",null,null,null,null,null,null,null,null,1,{"$f":"Tractors1!B4","v":0},{"$f":"TRUNC(Tractors1!B22,0)","v":0}]
["Annual loss of value,%",null,null,null,null,null,null,null,null,2,{"$f":"Tractors1!C4","v":0},{"$f":"TRUNC(Tractors1!C22,0)","v":0}]
["Calculation rate %",{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},null,3,{"$f":"Tractors1!D4","v":0},{"$f":"TRUNC(Tractors1!D22,0)","v":0}]
["Scrap value at end of period, Euro",{"$f":"B5*(1-B7)^B6","v":0},{"$f":"C5*(1-C7)^C6","v":0},0,0,0,0,0,null,4,{"$f":"Tractors1!E4","v":0},{"$f":"TRUNC(Tractors1!E22,0)","v":0}]
["Average capital costs, Euro / year",{"$f":"IF(AND(ISNUMBER(B5),ISNUMBER(B6),ISNUMBER(B7),ISNUMBER(B8)),PMT(B8,B6,B5,-B9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C5),ISNUMBER(C6),ISNUMBER(C7),ISNUMBER(C8)),PMT(C8,C6,C5,-C9)*-1,0)","v":0},0,0,0,0,0,{"$f":"SUM(B10:H10)","v":0},5,{"$f":"Tractors1!F4","v":0},{"$f":"TRUNC(Tractors1!F22,0)","v":0}]
["Average insurances euro/ year",null,null,null,null,null,null,null,{"$f":"SUM(B11:H11)","v":0},6,{"$f":"Tractors2!B4","v":0},{"$f":"TRUNC(Tractors2!B$22,0)","v":0}]
["Various costs Euro / year",null,null,null,null,null,null,null,{"$f":"SUM(B12:H12)","v":0},7,{"$f":"Tractors2!C4","v":0},{"$f":"TRUNC(Tractors2!C$22,0)","v":0}]
["Capacity costs, Euro / year",{"$f":"SUM(B10:B12)","v":0},{"$f":"SUM(C10:C12)","v":0},0,0,0,0,0,{"$f":"SUM(B13:H13)","v":0},8,{"$f":"Tractors2!D4","v":0},{"$f":"TRUNC(Tractors2!C$22,0)","v":0}]
["Maintenance, Euro / hour",null,null,null,null,null,null,null,null,9,{"$f":"Tractors2!E4","v":0},{"$f":"TRUNC(Tractors2!E$22,0)","v":0}]
["Tractor selection",null,null,null,null,null,null,null,null,10,{"$f":"Tractors2!F4","v":0},{"$f":"TRUNC(Tractors2!F$22,0)","v":0}]
["Tractor cost, Euro / hour",{"$f":"VLOOKUP(L30,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L31,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L32,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L33,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L34,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L35,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L36,$J$6:$L$16,3)","v":0},null,11,"(ingen traktor)",{"$f":"TRUNC(Tractors2!G$22,0)","v":0}]
["Unit costs, Euro / hour",{"$f":"B14+B16","v":0},{"$f":"C14+C16","v":0},0,0,0,0,0]
["Treated area, ha / year"]
["Capacity, ha / hour"]
["Hourly consumption / task, hours / year",{"$f":"IF(B19<>0,B18/B19,0)","v":0},{"$f":"IF(C19<>0,C18/C19,0)","v":0},0,0,0,0,0]
["Capacity costs, Euro / hour",{"$f":"IF(B18<>0,B13/B20,0)","v":0},{"$f":"IF(C18<>0,C13/C20,0)","v":0},0,0,0,0,0]
["Total cost, Euro / hour",{"$f":"B17+B21","v":0},{"$f":"C17+C21","v":0},0,0,0,0,0]
["Stykomkostninger, kr./ha",{"$f":"B17/B19","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Total cost, Euro / ha",{"$f":"IF(B19<>0,B22/B19,0)","v":0},{"$f":"IF(C19<>0,C22/C19,0)","v":0},0,0,0,0,0]
["Machine station rate, Euro / ha"]
["Result own machine, Euro./ha",{"$f":"B25-B24","v":0},{"$f":"C25-C24","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Database"]
[null,null,null,null,null,null,null,null,null,null,null,"Traktor","Timer"]
["Hourly consumption / work assignment",{"$f":"IF(B20<>0,B20,0)","v":0},0,0,0,0,0,{"$f":"IF(H20<>0,H20,0)","v":0},null,null,null,11,{"$f":"B30","v":0}]
[null,null,null,null,null,null,"Total hours/year =",{"$f":"SUM(B30:H30)","v":0},{"$f":"H31","v":0},null,null,11,{"$f":"C30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"D30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"E30","v":0}]
["Maintenance annually, DKK",{"$f":"B14*B30","v":0},{"$f":"C14*C30","v":0},0,0,0,0,0,{"$f":"SUM(B34:H34)","v":0},null,null,11,{"$f":"F30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"G30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"H30","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Kriterie","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor"]
[null,null,null,null,null,null,null,null,null,null,"Traktor",1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,"Sumtimer",{"$f":"DSUM($L$29:$M$36,\"Timer\",L38:L39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",M38:M39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",N38:N39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",O38:O39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",P38:P39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",Q38:Q39)","v":0},0,0,0,0]
[]
[]
["Result own machinery",{"$f":"B26*B18","v":0},0,0,0,0,0,0,{"$f":"SUM(B43:H43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,123456789123,123456789123,123456789123,123456789123,123456789123,123456789123,123456789123]

{"sheet":"Machines3","index":4,"n_rows":101,"n_cols":21,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
["Farm:",{"$f":"Result!F1","v":0},null,null,null,null,"Year",{"$f":"Result!F4","v":2021}]
["Costs for field work (change of units to pieces or tons)"]
[]
["Make / model:",null,null,null,"Make / model:"]
["Market value of the machine, Euro",null,null,null,"Market value of the machine, Euro",null,null,null,{"$f":"SUM(B5:H5)","v":0}]
["Calculation period, years",null,null,null,"Calculation period, years",null,null,null,null,1,{"$f":"Tractors1!B4","v":0},{"$f":"TRUNC(Tractors1!B22,0)","v":0}]
["Annual loss of value,%",null,null,null,"Annual loss of value,%",null,null,null,null,2,{"$f":"Tractors1!C4","v":0},{"$f":"TRUNC(Tractors1!C22,0)","v":0}]
["Calculation rate %",{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},"Calculation rate %",{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},null,3,{"$f":"Tractors1!D4","v":0},{"$f":"TRUNC(Tractors1!D22,0)","v":0}]
["Scrap value at end of period, Euro",{"$f":"B5*(1-B7)^B6","v":0},{"$f":"C5*(1-C7)^C6","v":0},0,"Scrap value at end of period, Euro",0,0,0,null,4,{"$f":"Tractors1!E4","v":0},{"$f":"TRUNC(Tractors1!E22,0)","v":0}]
["Average capital costs, Euro / year",{"$f":"IF(AND(ISNUMBER(B5),ISNUMBER(B6),ISNUMBER(B7),ISNUMBER(B8)),PMT(B8,B6,B5,-B9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C5),ISNUMBER(C6),ISNUMBER(C7),ISNUMBER(C8)),PMT(C8,C6,C5,-C9)*-1,0)","v":0},0,"Average capital costs, Euro / year",0,0,0,{"$f":"SUM(B10:H10)","v":0},5,{"$f":"Tractors1!F4","v":0},{"$f":"TRUNC(Tractors1!F22,0)","v":0}]
["Average insurances euro/ year",null,null,null,"Average insurances euro/ year",null,null,null,{"$f":"SUM(B11:H11)","v":0},6,{"$f":"Tractors2!B4","v":0},{"$f":"TRUNC(Tractors2!B$22,0)","v":0}]
["Various costs Euro / year",null,null,null,"Various costs Euro / year",null,null,null,{"$f":"SUM(B12:H12)","v":0},7,{"$f":"Tractors2!C4","v":0},{"$f":"TRUNC(Tractors2!C$22,0)","v":0}]
["Capacity costs, Euro / year",{"$f":"SUM(B10:B12)","v":0},{"$f":"SUM(C10:C12)","v":0},0,"Capacity costs, Euro / year",0,0,0,{"$f":"SUM(B13:H13)","v":0},8,{"$f":"Tractors2!D4","v":0},{"$f":"TRUNC(Tractors2!C$22,0)","v":0}]
["Maintenance, Euro / hour",null,null,null,"Maintenance, Euro / hour",null,null,null,null,9,{"$f":"Tractors2!E4","v":0},{"$f":"TRUNC(Tractors2!E$22,0)","v":0}]
["Tractor selection",null,null,null,"Tractor selection",null,null,null,null,10,{"$f":"Tractors2!F4","v":0},{"$f":"TRUNC(Tractors2!F$22,0)","v":0}]
["Tractor cost, Euro / hour",{"$f":"VLOOKUP(L30,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L31,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L32,$J$6:$L$16,3)","v":0},"Tractor cost, Euro / hour",{"$f":"VLOOKUP(L34,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L35,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L36,$J$6:$L$16,3)","v":0},null,11,"(ingen traktor)",{"$f":"TRUNC(Tractors2!G$22,0)","v":0}]
["Unit costs, Euro / hour",{"$f":"B14+B16","v":0},{"$f":"C14+C16","v":0},0,"Unit costs, Euro / hour",{"$f":"F14+F16","v":0},0,0]
[{"$f":"VLOOKUP($J$22,$J$24:$O$26,2)","v":"Tons/år i alt"},null,null,null,{"$f":"VLOOKUP($K$22,$J$24:$O$26,2)","v":"Tons/år i alt"}]
[]
["Hourly consumption/work, h/year",{"$f":"IF(B19<>0,B18/B19,0)","v":0},{"$f":"IF(C19<>0,C18/C19,0)","v":0},0,"Hourly consumption/work, h/year",{"$f":"IF(F19<>0,F18/F19,0)","v":0},{"$f":"IF(G19<>0,G18/G19,0)","v":0},0]
[{"$f":"VLOOKUP($J$22,$J$24:$O$26,4)","v":"Stykomkostninger, kr./ton"},{"$f":"IF(B18<>0,B17*B30/B18,0)","v":0},{"$f":"IF(C18<>0,C17*C30/C18,0)","v":0},{"$f":"IF(D18<>0,D17*D30/D18,0)","v":0},{"$f":"VLOOKUP($K$22,$J$24:$O$26,4)","v":"Stykomkostninger, kr./ton"},{"$f":"IF(F18<>0,F17*F30/F18,0)","v":0},{"$f":"IF(G18<>0,G17*G30/G18,0)","v":0},{"$f":"IF(H18<>0,H17*H30/H18,0)","v":0}]
[{"$f":"VLOOKUP($J$22,$J$24:$O$26,5)","v":"Kapacitetsomkostninger, kr./ton"},{"$f":"IF(B18<>0,B13/B18,0)","v":0},{"$f":"IF(C18<>0,C13/C18,0)","v":0},0,{"$f":"VLOOKUP($K$22,$J$24:$O$26,5)","v":"Kapacitetsomkostninger, kr./ton"},{"$f":"IF(F18<>0,F13/F18,0)","v":0},{"$f":"IF(G18<>0,G13/G18,0)","v":0},0,null,1,1]
[{"$f":"VLOOKUP($J$22,$J$24:$O$26,6)","v":"I alt omkostning, kr./ton"},{"$f":"B21+B22","v":0},0,{"$f":"D21+D22","v":0},{"$f":"VLOOKUP($K$22,$J$24:$O$26,6)","v":"I alt omkostning, kr./ton"},{"$f":"F21+F22","v":0},0,0,null,1,2,3,4,5,6,7,8,9]
[{"$f":"VLOOKUP($J$22,$J$24:$Q$26,7)","v":"Maskinstationstakst, kr./ton"},null,null,null,{"$f":"VLOOKUP($K$22,$J$24:$Q$26,7)","v":"Maskinstationstakst, kr./ton"},null,null,null,null,1,"Tons/år i alt","Kapacitet, ton/time","Stykomkostninger, kr./ton","Kapacitetsomkostninger, kr./ton","I alt omkostning, kr./ton","Maskinstationstakst, kr./ton","Resultat egen maskine, kr./ton","ton"]
[{"$f":"VLOOKUP($J$22,$J$24:$Q$26,8)","v":"Resultat egen maskine, kr./ton"},{"$f":"B24-B23","v":0},{"$f":"C24-C23","v":0},{"$f":"D24-D23","v":0},{"$f":"VLOOKUP($K$22,$J$24:$Q$26,8)","v":"Resultat egen maskine, kr./ton"},{"$f":"F24-F23","v":0},{"$f":"G24-G23","v":0},{"$f":"H24-H23","v":0},null,2,"Stk./år i alt","Kapacitet, stk./time","Stykomkostninger, kr./stk.","Kapacitetsomkostninger, kr./stk","I alt omkostning, kr./stk","Maskinstationstakst, kr./stk","Resultat egen maskine, kr./stk","stk."]
[null,null,null,null,null,null,null,null,null,3,"Timer/år i alt","Kapacitet, ha/time","Stykomkostninger, kr./ha","Kapacitetsomkostninger, kr./ha","I alt omkostning, kr./ha","Maskinstationstakst, kr./ha","Resultat egen maskine, kr./ha","time"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Database"]
[null,null,null,null,null,null,null,null,null,null,null,"Traktor","Timer"]
["Hourly consu. / work assignment",{"$f":"IF(B20<>0,B20,0)","v":0},0,0,null,{"$f":"IF(F20<>0,F20,0)","v":0},0,0,null,null,null,11,{"$f":"B30","v":0}]
[null,null,null,null,null,null,"Total hours/year =",{"$f":"SUM(B30:H30)","v":0},{"$f":"H31","v":0},null,null,11,{"$f":"C30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"D30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Maintenance annually, Euro",{"$f":"B14*B30","v":0},{"$f":"C14*C30","v":0},0,null,0,0,0,{"$f":"SUM(B34:H34)","v":0},null,null,11,{"$f":"F30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"G30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"H30","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Kriterie","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor"]
[null,null,null,null,null,null,null,null,null,null,"Traktor",1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,"Sumtimer",{"$f":"DSUM($L$29:$M$36,\"Timer\",L38:L39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",M38:M39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",N38:N39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",O38:O39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",P38:P39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",Q38:Q39)","v":0},0,0,0,0]
[]
[]
["Result own machinery",{"$f":"B25*B18","v":0},{"$f":"C25*C18","v":0},0,null,0,0,0,{"$f":"SUM(B43:H43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,123456789123,123456789123,123456789123,null,123456789123,123456789123,123456789123]

{"sheet":"Machines4","index":5,"n_rows":101,"n_cols":21,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
["Farm:",{"$f":"Result!F1","v":0},null,null,null,null,"Year:",{"$f":"Result!F4","v":2021}]
["Costs for field work (change of units to pieces or tons)"]
[]
["Make / model:",null,null,null,"Make / model:"]
["Market value of the machine, Euro",null,null,null,"Market value of the machine, Euro",null,null,null,{"$f":"SUM(B5:H5)","v":0}]
["Calculation period, years",null,null,null,"Calculation period, years",null,null,null,null,1,{"$f":"Tractors1!B4","v":0},{"$f":"TRUNC(Tractors1!B22,0)","v":0}]
["Annual loss of value,%",null,null,null,"Annual loss of value,%",null,null,null,null,2,{"$f":"Tractors1!C4","v":0},{"$f":"TRUNC(Tractors1!C22,0)","v":0}]
["Calculation rate %",{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},"Calculation rate %",{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},null,3,{"$f":"Tractors1!D4","v":0},{"$f":"TRUNC(Tractors1!D22,0)","v":0}]
["Scrap value at end of period, Euro",{"$f":"B5*(1-B7)^B6","v":0},{"$f":"C5*(1-C7)^C6","v":0},0,"Scrap value at end of period, Euro",0,0,0,null,4,{"$f":"Tractors1!E4","v":0},{"$f":"TRUNC(Tractors1!E22,0)","v":0}]
["Average capital costs, Euro / year",{"$f":"IF(AND(ISNUMBER(B5),ISNUMBER(B6),ISNUMBER(B7),ISNUMBER(B8)),PMT(B8,B6,B5,-B9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C5),ISNUMBER(C6),ISNUMBER(C7),ISNUMBER(C8)),PMT(C8,C6,C5,-C9)*-1,0)","v":0},0,"Average capital costs, Euro / year",0,0,0,{"$f":"SUM(B10:H10)","v":0},5,{"$f":"Tractors1!F4","v":0},{"$f":"TRUNC(Tractors1!F22,0)","v":0}]
["Average insurances euro/ year",null,null,null,"Average insurances euro/ year",null,null,null,{"$f":"SUM(B11:H11)","v":0},6,{"$f":"Tractors2!B4","v":0},{"$f":"TRUNC(Tractors2!B$22,0)","v":0}]
["Various costs Euro / year",null,null,null,"Various costs Euro / year",null,null,null,{"$f":"SUM(B12:H12)","v":0},7,{"$f":"Tractors2!C4","v":0},{"$f":"TRUNC(Tractors2!C$22,0)","v":0}]
["Capacity costs, Euro / year",{"$f":"SUM(B10:B12)","v":0},{"$f":"SUM(C10:C12)","v":0},0,"Capacity costs, Euro / year",0,0,0,{"$f":"SUM(B13:H13)","v":0},8,{"$f":"Tractors2!D4","v":0},{"$f":"TRUNC(Tractors2!C$22,0)","v":0}]
["Maintenance, Euro / hour",null,null,null,"Maintenance, Euro / hour",null,null,null,null,9,{"$f":"Tractors2!E4","v":0},{"$f":"TRUNC(Tractors2!E$22,0)","v":0}]
["Tractor selection",null,null,null,"Tractor selection",null,null,null,null,10,{"$f":"Tractors2!F4","v":0},{"$f":"TRUNC(Tractors2!F$22,0)","v":0}]
["Tractor cost, Euro / hour",{"$f":"VLOOKUP(L30,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L31,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L32,$J$6:$L$16,3)","v":0},"Tractor cost, Euro / hour",{"$f":"VLOOKUP(L34,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L35,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L36,$J$6:$L$16,3)","v":0},null,11,"(ingen traktor)",{"$f":"TRUNC(Tractors2!G$22,0)","v":0}]
["Unit costs, Euro / hour",{"$f":"B14+B16","v":0},{"$f":"C14+C16","v":0},0,"Unit costs, Euro / hour",{"$f":"F14+F16","v":0},0,0]
[{"$f":"VLOOKUP($J$22,$J$24:$O$26,2)","v":"Timer/år i alt"},null,null,null,{"$f":"VLOOKUP($K$22,$J$24:$O$26,2)","v":"Timer/år i alt"}]
[]
["Hourly consump./work, hours/year",{"$f":"IF(B19<>0,B18/B19,0)","v":0},{"$f":"IF(C19<>0,C18/C19,0)","v":0},0,"Hourly consump./work, hours/year",{"$f":"IF(F19<>0,F18/F19,0)","v":0},{"$f":"IF(G19<>0,G18/G19,0)","v":0},0,null,null,2]
[{"$f":"VLOOKUP($J$22,$J$24:$O$26,4)","v":"Stykomkostninger, kr./ha"},{"$f":"IF(B18<>0,B17*B30/B18,0)","v":0},{"$f":"IF(C18<>0,C17*C30/C18,0)","v":0},{"$f":"IF(D18<>0,D17*D30/D18,0)","v":0},{"$f":"VLOOKUP($K$22,$J$24:$O$26,4)","v":"Stykomkostninger, kr./ha"},{"$f":"IF(F18<>0,F17*F30/F18,0)","v":0},{"$f":"IF(G18<>0,G17*G30/G18,0)","v":0},{"$f":"IF(H18<>0,H17*H30/H18,0)","v":0}]
[{"$f":"VLOOKUP($J$22,$J$24:$O$26,5)","v":"Kapacitetsomkostninger, kr./ha"},{"$f":"IF(B18<>0,B13/B18,0)","v":0},{"$f":"IF(C18<>0,C13/C18,0)","v":0},0,{"$f":"VLOOKUP($K$22,$J$24:$O$26,5)","v":"Kapacitetsomkostninger, kr./ha"},{"$f":"IF(F18<>0,F13/F18,0)","v":0},{"$f":"IF(G18<>0,G13/G18,0)","v":0},0,null,3,3]
[{"$f":"VLOOKUP($J$22,$J$24:$O$26,6)","v":"I alt omkostning, kr./ha"},{"$f":"B21+B22","v":0},0,{"$f":"D21+D22","v":0},{"$f":"VLOOKUP($K$22,$J$24:$O$26,6)","v":"I alt omkostning, kr./ha"},{"$f":"F21+F22","v":0},0,0,null,1,2,3,4,5,6,7,8,9]
[{"$f":"VLOOKUP($J$22,$J$24:$Q$26,7)","v":"Maskinstationstakst, kr./ha"},null,null,null,{"$f":"VLOOKUP($K$22,$J$24:$Q$26,7)","v":"Maskinstationstakst, kr./ha"},null,null,null,null,1,"Tons/år i alt","Kapacitet, ton/time","Stykomkostninger, kr./ton","Kapacitetsomkostninger, kr./ton","I alt omkostning, kr./ton","Maskinstationstakst, kr./ton","Resultat egen maskine, kr./ton","ton"]
[{"$f":"VLOOKUP($J$22,$J$24:$Q$26,8)","v":"Resultat egen maskine, kr./ha"},{"$f":"B24-B23","v":0},{"$f":"C24-C23","v":0},{"$f":"D24-D23","v":0},{"$f":"VLOOKUP($K$22,$J$24:$Q$26,8)","v":"Resultat egen maskine, kr./ha"},{"$f":"F24-F23","v":0},{"$f":"G24-G23","v":0},{"$f":"H24-H23","v":0},null,2,"Stk./år i alt","Kapacitet, stk./time","Stykomkostninger, kr./stk.","Kapacitetsomkostninger, kr./stk","I alt omkostning, kr./stk","Maskinstationstakst, kr./stk","Resultat egen maskine, kr./stk","stk."]
[null,null,null,null,null,null,null,null,null,3,"Timer/år i alt","Kapacitet, ha/time","Stykomkostninger, kr./ha","Kapacitetsomkostninger, kr./ha","I alt omkostning, kr./ha","Maskinstationstakst, kr./ha","Resultat egen maskine, kr./ha","time"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Database"]
[null,null,null,null,null,null,null,null,null,null,null,"Traktor","Timer"]
["Hourly consumption / work assignment",{"$f":"IF(B20<>0,B20,0)","v":0},0,0,null,{"$f":"IF(F20<>0,F20,0)","v":0},0,0,null,null,null,11,{"$f":"B30","v":0}]
[null,null,null,null,null,null,"Total hours/year =",{"$f":"SUM(B30:H30)","v":0},{"$f":"H31","v":0},null,null,11,{"$f":"C30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"D30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Maintenance annually, Euro",{"$f":"B14*B30","v":0},{"$f":"C14*C30","v":0},0,null,0,0,0,{"$f":"SUM(B34:H34)","v":0},null,null,11,{"$f":"F30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"G30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"H30","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Kriterie","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor"]
[null,null,null,null,null,null,null,null,null,null,"Traktor",1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,"Sumtimer",{"$f":"DSUM($L$29:$M$36,\"Timer\",L38:L39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",M38:M39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",N38:N39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",O38:O39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",P38:P39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",Q38:Q39)","v":0},0,0,0,0]
[]
[]
["Result own machinery",{"$f":"B25*B18","v":0},{"$f":"C25*C18","v":0},0,null,0,0,0,{"$f":"SUM(B43:H43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,123456789123,123456789123,123456789123,null,123456789123,123456789123,123456789123]

{"sheet":"Trailers","index":6,"n_rows":101,"n_cols":21,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
["Farm:",{"$f":"Result!F1","v":0},null,null,null,null,"Year:",{"$f":"Result!F4","v":2021}]
["Cost of Trailers"]
[]
["Make / model:",null,null,null,"Make / model:"]
["Market value of the machine, Euro",null,null,null,"Market value of the machine, Euro",null,null,null,{"$f":"SUM(B5:H5)","v":0}]
["Calculation period, years",null,null,null,"Calculation period, years",null,null,null,null,1,{"$f":"Tractors1!B4","v":0},{"$f":"TRUNC(Tractors1!B22,0)","v":0}]
["Annual loss of value,%",null,null,null,"Annual loss of value,%",null,null,null,null,2,{"$f":"Tractors1!C4","v":0},{"$f":"TRUNC(Tractors1!C22,0)","v":0}]
["Calculation rate %",{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},"Calculation rate %",{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},{"$f":"Result!$F$3","v":0},null,3,{"$f":"Tractors1!D4","v":0},{"$f":"TRUNC(Tractors1!D22,0)","v":0}]
["Scrap value at end of period, Euro",{"$f":"B5*(1-B7)^B6","v":0},{"$f":"C5*(1-C7)^C6","v":0},0,"Scrap value at end of period, Euro",0,0,0,null,4,{"$f":"Tractors1!E4","v":0},{"$f":"TRUNC(Tractors1!E22,0)","v":0}]
["Average capital costs, Euro / year",{"$f":"IF(AND(ISNUMBER(B5),ISNUMBER(B6),ISNUMBER(B7),ISNUMBER(B8)),PMT(B8,B6,B5,-B9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C5),ISNUMBER(C6),ISNUMBER(C7),ISNUMBER(C8)),PMT(C8,C6,C5,-C9)*-1,0)","v":0},0,"Average capital costs, Euro / year",0,0,0,{"$f":"SUM(B10:H10)","v":0},5,{"$f":"Tractors1!F4","v":0},{"$f":"TRUNC(Tractors1!F22,0)","v":0}]
["Average insurances euro/ year",null,null,null,"Average insurances euro/ year",null,null,null,{"$f":"SUM(B11:H11)","v":0},6,{"$f":"Tractors2!B4","v":0},{"$f":"TRUNC(Tractors2!B$22,0)","v":0}]
["Various costs Euro / year",null,null,null,"Various costs Euro / year",null,null,null,{"$f":"SUM(B12:H12)","v":0},7,{"$f":"Tractors2!C4","v":0},{"$f":"TRUNC(Tractors2!C$22,0)","v":0}]
["Capacity costs, Euro / year",{"$f":"SUM(B10:B12)","v":0},{"$f":"SUM(C10:C12)","v":0},0,"Capacity costs, Euro / year",0,0,0,{"$f":"SUM(B13:H13)","v":0},8,{"$f":"Tractors2!D4","v":0},{"$f":"TRUNC(Tractors2!C$22,0)","v":0}]
["Maintenance, Euro / hour",null,null,null,"Maintenance, Euro / hour",null,null,null,null,9,{"$f":"Tractors2!E4","v":0},{"$f":"TRUNC(Tractors2!E$22,0)","v":0}]
["Tractor selection",null,null,null,"Tractor selection",null,null,null,null,10,{"$f":"Tractors2!F4","v":0},{"$f":"TRUNC(Tractors2!F$22,0)","v":0}]
["Tractor cost, Euro / hour",{"$f":"VLOOKUP(L30,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L31,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L32,$J$6:$L$16,3)","v":0},"Tractor cost, Euro / hour",{"$f":"VLOOKUP(L34,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L35,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L36,$J$6:$L$16,3)","v":0},null,11,"(ingen traktor)",{"$f":"TRUNC(Tractors2!G$22,0)","v":0}]
["Unit costs, Euro / hour",{"$f":"B14+B16","v":0},{"$f":"C14+C16","v":0},0,"Unit costs, Euro / hour",{"$f":"F14+F16","v":0},0,0]
[{"$f":"VLOOKUP($J$20,$J$22:$O$24,2)","v":"Tons/år i alt"},null,null,null,{"$f":"VLOOKUP($K$20,$J$22:$O$24,2)","v":"Tons/år i alt"}]
[]
["Hourly consump./work, hours year",{"$f":"IF(B19<>0,B18/B19,0)","v":0},{"$f":"IF(C19<>0,C18/C19,0)","v":0},{"$f":"IF(D19<>0,D18/D19,0)","v":0},"Hourly consump./work, hours year",{"$f":"IF(F19<>0,F18/F19,0)","v":0},0,0,null,1,1]
[{"$f":"VLOOKUP($J$20,$J$22:$O$24,4)","v":"Stykomkostninger, kr./ton"},{"$f":"IF(B18<>0,B17*B30/B18,0)","v":0},{"$f":"IF(C18<>0,C17*C30/C18,0)","v":0},{"$f":"IF(D18<>0,D17*D30/D18,0)","v":0},{"$f":"VLOOKUP($K$20,$J$22:$O$25,4)","v":"Stykomkostninger, kr./ton"},{"$f":"IF(F18<>0,F17*F30/F18,0)","v":0},{"$f":"IF(G18<>0,G17*G30/G18,0)","v":0},{"$f":"IF(H18<>0,H17*H30/H18,0)","v":0},null,1,2,3,4,5,6,7,8,9]
[{"$f":"VLOOKUP($J$20,$J$22:$O$24,5)","v":"Kapacitetsomkostninger, kr./ton"},{"$f":"IF(B18<>0,B13/B18,0)","v":0},{"$f":"IF(C18<>0,C13/C18,0)","v":0},{"$f":"IF(D18<>0,D13/D18,0)","v":0},{"$f":"VLOOKUP($K$20,$J$22:$O$25,5)","v":"Kapacitetsomkostninger, kr./ton"},{"$f":"IF(F18<>0,F13/F18,0)","v":0},{"$f":"IF(G18<>0,G13/G18,0)","v":0},{"$f":"IF(H18<>0,H13/H18,0)","v":0},null,1,"Tons/år i alt","Kapacitet, ton/time","Stykomkostninger, kr./ton","Kapacitetsomkostninger, kr./ton","I alt omkostning, kr./ton","Maskinstationstakst, kr./ton","Resultat egen maskine, kr./ton","ton"]
[{"$f":"VLOOKUP($J$20,$J$22:$O$24,6)","v":"I alt omkostning, kr./ton"},{"$f":"B21+B22","v":0},{"$f":"C21+C22","v":0},{"$f":"D21+D22","v":0},{"$f":"VLOOKUP($K$20,$J$22:$O$25,6)","v":"I alt omkostning, kr./ton"},{"$f":"F21+F22","v":0},0,0,null,2,"Stk./år i alt","Kapacitet, stk./time","Stykomkostninger, kr./stk.","Kapacitetsomkostninger, kr./stk","I alt omkostning, kr./stk","Maskinstationstakst, kr./stk","Resultat egen maskine, kr./stk","stk."]
[{"$f":"VLOOKUP($J$20,$J$22:$Q$24,7)","v":"Maskinstationstakst, kr./ton"},null,null,null,{"$f":"VLOOKUP($K$20,$J$22:$Q$25,7)","v":"Maskinstationstakst, kr./ton"},null,null,null,null,3,"Timer/år i alt","Kapacitet, time/time","Stykomkostninger, kr./time","Kapacitetsomkostninger, kr./time","I alt omkostning, kr./time","Maskinstationstakst, kr./time","Resultat egen maskine, kr./time","time"]
[{"$f":"VLOOKUP($J$20,$J$22:$Q$24,8)","v":"Resultat egen maskine, kr./ton"},{"$f":"B24-B23","v":0},{"$f":"C24-C23","v":0},{"$f":"D24-D23","v":0},{"$f":"VLOOKUP($K$20,$J$22:$Q$25,8)","v":"Resultat egen maskine, kr./ton"},{"$f":"F24-F23","v":0},{"$f":"G24-G23","v":0},{"$f":"H24-H23","v":0},{"$f":"SUM(B25:H25)","v":0},4,"Ha/år i alt","Kapacitet, ha/time","Stykomokostninger, kr./ha","Kapacitetsomkostninger, kr./ha","I alt omkostning, kr./ha","Maskinstationstakst, kr./ha","Resultat egen maskine, kr./ha","time"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Database"]
[null,null,null,null,null,null,null,null,null,null,null,"Traktor","Timer"]
["Hourly consumption / work assignment",{"$f":"IF(B16<>0,B18/IF(B19>0,B19,1),0)","v":0},{"$f":"IF(C16<>0,C18/IF(C19>0,C19,1),0)","v":0},{"$f":"IF(D16<>0,D18/IF(D19>0,D19,1),0)","v":0},null,{"$f":"IF(F16<>0,F18/IF(F19>0,F19,1),0)","v":0},{"$f":"IF(G16<>0,G18/IF(G19>0,G19,1),0)","v":0},{"$f":"IF(H16<>0,H18/IF(H19>0,H19,1),0)","v":0},null,null,null,11,{"$f":"B30","v":0}]
[null,null,null,null,null,null,"Total hours/year =",{"$f":"SUM(B30:H30)","v":0},{"$f":"H31","v":0},null,null,11,{"$f":"C30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"D30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Maintenance annually, Euro",{"$f":"B14*B30","v":0},{"$f":"C14*C30","v":0},0,null,0,0,0,{"$f":"SUM(B34:H34)","v":0},null,null,11,{"$f":"F30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"G30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"H30","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Kriterie","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor"]
[null,null,null,null,null,null,null,null,null,null,"Traktor",1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,"Sumtimer",{"$f":"DSUM($L$29:$M$36,\"Timer\",L38:L39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",M38:M39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",N38:N39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",O38:O39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",P38:P39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",Q38:Q39)","v":0},0,0,0,0]
[null,123456789123,123456789123,123456789123,null,123456789123,123456789123,123456789123]
[]
["Resultat egne maskiner",{"$f":"B25*B18","v":0},{"$f":"C25*C18","v":0},0,null,0,0,0,{"$f":"SUM(B43:H43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,123456789123,123456789123,123456789123,null,123456789123,123456789123,123456789123]

{"sheet":"Result","index":7,"n_rows":102,"n_cols":19,"rows_kept":102,"cut":false,"hidden":false,"merged":[[20,5,21,5],[41,7,42,7],[41,8,42,8],[35,7,36,7],[35,8,36,8],[37,7,38,7],[37,8,38,8],[39,7,40,7],[39,8,40,8],[29,7,30,7],[29,8,30,8],[31,7,32,7],[31,8,32,8],[33,7,34,7],[33,8,34,8],[23,7,24,7],[23,8,24,8],[25,7,26,7],[25,8,26,8],[27,7,28,7],[27,8,28,8],[17,7,18,7],[17,8,18,8],[19,7,20,7],[19,8,20,8],[21,7,22,7],[21,8,22,8],[11,7,12,7],[11,8,12,8],[13,7,14,7],[13,8,14,8],[15,7,16,7],[15,8,16,8],[1,3,1,4],[2,3,2,4],[4,3,4,4],[9,7,10,7],[9,8,10,8]]}
["Property information and key figures",null,null,null,"Farm:"]
[null,null,null,"Cultivated area, ha"]
[null,null,null,"Calculationsrate %",null,0]
[null,null,null,null,"Year: ",2021]
[null,null,null,"Fuel, Euro / liter",null,0.9]
[]
[]
["Euro",null,null,"Total Euro/year","Avg. Euro./ha","Annual report",null,"Indicative percentages for annual value loss                                                         (from technical advisor Karl Jørgen Nielsen February 2013)","Estimated annual loss of value"]
["Booked value machines opening balance, Euro",null,null,{"$f":"Trailers!I5+Machines4!I5+Machines3!I5+Machines2!I5+Machines!I5+Tractors1!I5+Tractors2!I5","v":0},{"$f":"IF(ISNUMBER($F$2),D9/$F$2,0)","v":0},null,null,"Simple machines (without technology development) and without motors and which are not PTO driven",12]
["Machine station income, Euro",null,null,{"$f":"F10","v":0},{"$f":"IF(ISNUMBER($F$2),D10/$F$2,0)","v":0},null,null,"Brand new tractors, with large annual use over (1000 hours per year).",15]
["Machine station cost, Euro",null,null,{"$f":"F11","v":0},{"$f":"IF(ISNUMBER($F$2),D11/$F$2,0)","v":0}]
[null,null,null,null,null,null,null,"Brand new tractors, with little annual use under 1000 hours a year",12]
["Hours",null,null,"Total hours/year","Avg. hours/ha"]
["Hours of fieldwork",null,null,{"$f":"Trailers!I31+Machines4!I31+Machines3!I31+Machines2!I31+Machines!I31+Tractors1!I33+Tractors2!I33","v":0},{"$f":"IF(ISNUMBER($F$2),D14/$F$2,0)","v":0},null,null,"Older tractors, with large annual use over 1000 hours per year",17,null,null,null,null,null,null,null,null,"Egne maskinomkostninger pr. ha, Data til lagkage"]
["Hours for maintenance in own workshop",null,null,null,{"$f":"IF(ISNUMBER($F$2),D15/$F$2,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Wage pr. ha",{"$f":"E21+E22","v":0}]
["Hours in total field, transport and maintenance",null,null,{"$f":"SUM(D14:D15)","v":0},{"$f":"IF(ISNUMBER($F$2),D16/$F$2,0)","v":0},null,null,"Older tractors, with small annual use over 1000 hours per year",14,null,null,null,null,null,null,null,null,"Unit costs excl. salary per. Ha",{"$f":"E19+E20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capacity cost per. Ha",{"$f":"E27","v":0}]
["Machine costs",null,null,"Total Euro/year","Avg. Euro./ha","Annual report",null,"Brand new combine harvesters and balers with large annual use over 200 ha per year"," 11-13"]
["Maintenance, Euro",null,null,{"$f":"R19","v":0},{"$f":"IF(ISNUMBER($F$2),D19/$F$2,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Trailers!I34+Machines4!I34+Machines3!I34+Machines2!I34+Machines!I34+Tractors1!I36+Tractors2!I36","v":0},"Maintenance annually, Euro"]
["Fuel, Euro",null,null,{"$f":"R20","v":0},0,null,null,"Brand new combine harvesters and balers with a small annual use of less than 200 ha per year"," 9-11",null,null,null,null,null,null,null,null,{"$f":"Trailers!I35+Machines4!I35+Machines3!I35+Machines2!I35+Machines!I35+Tractors1!I37+Tractors2!I37","v":0},"Fuel annually, Euro"]
["Wage: tractor, combine and sprayer, Euro",null,null,{"$f":"R21","v":0},{"$f":"IF(ISNUMBER($F$2),D21/$F$2,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tractors1!I38+Tractors2!I38","v":0},"Wage cost annually, Euro"]
["Wages, maintenance                Hourly wages:",null,null,{"$f":"D15*B22","v":0},0,null,null,"Older combine harvesters and balers with large annual use over 200 ha per year","13-15"]
["Unit costs, Euro",null,null,{"$f":"SUM(D19:D22)","v":0},0]
["Insurance, Euro",null,null,{"$f":"R24","v":0},0,null,null,"Older combine harvesters and balers with a small annual use of less than 200 ha per year"," 12-13",null,null,null,null,null,null,null,null,{"$f":"Trailers!I11+Machines4!I11+Machines3!I11+Machines2!I11+Machines!I11+Tractors1!I11+Tractors2!I11","v":0},"Insurance"]
["Various, etc., Euro",null,null,{"$f":"R25","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Trailers!I12+Machines4!I12+Machines3!I12+Machines2!I12+Machines!I12+Tractors1!I12+Tractors2!I12","v":0},"Various"]
["Value loss and interest, Euro",null,null,{"$f":"R26","v":0},0,null,null,"Brand new self-propelled sprayer with large annual use over 1000 ha per year"," 12-15",null,null,null,null,null,null,null,null,{"$f":"Trailers!I13+Machines4!I13+Machines3!I13+Machines2!I13+Machines!I13+Tractors1!I13+Tractors2!I13","v":0},"GKO total"]
["Total capacity costs, Euro",null,null,{"$f":"SUM(D24:D26)","v":0},{"$f":"IF(ISNUMBER($F$2),ROUND(D27/$F$2,0),0)","v":0}]
["Net machine station, Euro",null,null,{"$f":"(D10-D11)*-1","v":0},0,null,null,"Brand new self-propelled sprayer with small annual use under 1000 ha per year"," 10-12"]
["Total machine costs, Euro with salary",null,null,{"$f":"D23+D27+D28","v":0},0]
["Total machine costs, Euro without salary",null,null,{"$f":"D29-D21-D22","v":0},0,null,null,"Older self-propelled sprayer with large annual use over 1000 ha per year","15-18"]
[]
["Machine house result",null,null,"Total Euro/year",null,null,null,"Older self-propelled sprayer with small annual use under 1000 ha per year"," 12-14"]
["Result own machines, Euro in total / year",null,null,{"$f":"Trailers!I43+Machines4!I43+Machines3!I43+Machines2!I43+Machines!I43+Tractors1!I41+Tractors2!I41","v":0}]
["Wage, maintenance, DKK in total / year",null,null,{"$f":"D22*-1","v":0},null,null,null,"Ordinary trailer sprayer with large annual use over 1000ha"," 12-14"]
["Undistributed tractor costs, Euro in total / year",null,null,{"$f":"Tractors1!I42+Tractors2!I42","v":0}]
["Result machine house, Euro in total / year",null,null,{"$f":"SUM(D33:D35)","v":0},null,null,null,"Ordinary trailer sprayer with small annual use under 1000ha"," 10-12"]
[]
[null,null,null,null,null,null,null,"Simple machines such as plows and harrows",12]
[]
[null,null,null,null,null,null,null,"Rotor seed set",12]
[]
[null,null,null,null,null,null,null,"Combi seeding set",12]
[]
[null,null,null,null,null,null,null,"Wagons for straw and grain, etc.","8 or 10"]
[null,null,null,null,null,null,null,"Slurry equipment",15]
[]
[]
[]
[]
[]
[]
[]
[]
["Kommentarer:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1234,12,123456789123,123456789123,123456789123]

{"sheet":"Machine list","index":8,"n_rows":86,"n_cols":5,"rows_kept":86,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
["Machine list",null,null,"Year",{"$f":"Result!F4","v":2021}]
[{"$f":"Result!F1","v":0}]
[]
[]
["Tractor","Trade value, Euro","Annual loss of value,%","Use, hours / year","Total cost, Euro / hour"]
[{"$f":"Tractors1!B$4","v":0},{"$f":"Tractors1!B$5","v":0},{"$f":"Tractors1!B$7","v":0},{"$f":"Tractors1!B$19","v":0},{"$f":"Tractors1!B$22","v":0}]
[{"$f":"Tractors1!C$4","v":0},{"$f":"Tractors1!C$5","v":0},{"$f":"Tractors1!C$7","v":0},{"$f":"Tractors1!C$19","v":0},{"$f":"Tractors1!C$22","v":0}]
[{"$f":"Tractors1!D$4","v":0},{"$f":"Tractors1!D$5","v":0},{"$f":"Tractors1!D$7","v":0},{"$f":"Tractors1!D$19","v":0},{"$f":"Tractors1!D$22","v":0}]
[{"$f":"Tractors1!E$4","v":0},{"$f":"Tractors1!E$5","v":0},{"$f":"Tractors1!E$7","v":0},{"$f":"Tractors1!E$19","v":0},{"$f":"Tractors1!E$22","v":0}]
[{"$f":"Tractors1!F$4","v":0},{"$f":"Tractors1!F$5","v":0},{"$f":"Tractors1!F$7","v":0},{"$f":"Tractors1!F$19","v":0},{"$f":"Tractors1!F$22","v":0}]
[{"$f":"Tractors2!B$4","v":0},{"$f":"Tractors2!B$5","v":0},{"$f":"Tractors2!B$7","v":0},{"$f":"Tractors2!B$19","v":0},{"$f":"Tractors2!B$22","v":0}]
[{"$f":"Tractors2!C$4","v":0},{"$f":"Tractors2!C$5","v":0},{"$f":"Tractors2!C$7","v":0},{"$f":"Tractors2!C$19","v":0},{"$f":"Tractors2!C$22","v":0}]
[{"$f":"Tractors2!D$4","v":0},{"$f":"Tractors2!D$5","v":0},{"$f":"Tractors2!D$7","v":0},{"$f":"Tractors2!D$19","v":0},{"$f":"Tractors2!D$22","v":0}]
[{"$f":"Tractors2!E$4","v":0},{"$f":"Tractors2!E$5","v":0},{"$f":"Tractors2!E$7","v":0},{"$f":"Tractors2!E$19","v":0},{"$f":"Tractors2!E$22","v":0}]
[{"$f":"Tractors2!F$4","v":0},{"$f":"Tractors2!F$5","v":0},{"$f":"Tractors2!F$7","v":0},{"$f":"Tractors2!F$19","v":0},{"$f":"Tractors2!F$22","v":0}]
["Combine/sprayer","Trade value, Euro","Annual loss of value,%","Use, ha / year","Total cost, Euro / ha"]
[{"$f":"Tractors1!G$4","v":0},{"$f":"Tractors1!G$5","v":0},{"$f":"Tractors1!G$7","v":0},{"$f":"Tractors1!G$24","v":0},{"$f":"Tractors1!G$25","v":0}]
[{"$f":"Tractors1!H$4","v":0},{"$f":"Tractors1!H$5","v":0},{"$f":"Tractors1!H$7","v":0},{"$f":"Tractors1!H$24","v":0},{"$f":"Tractors1!H$25","v":0}]
[{"$f":"Tractors2!G$4","v":0},{"$f":"Tractors2!G$5","v":0},{"$f":"Tractors2!G$7","v":0},{"$f":"Tractors2!G$24","v":0},{"$f":"Tractors2!G$25","v":0}]
[{"$f":"Tractors2!H$4","v":0},{"$f":"Tractors2!H$5","v":0},{"$f":"Tractors2!H$7","v":0},{"$f":"Tractors2!H$24","v":0},{"$f":"Tractors2!H$25","v":0}]
["Machines","Trade value, Euro","Annual loss of value,%","Use, ha / year","Total cost, Euro / ha"]
[{"$f":"Machines!B$4","v":0},{"$f":"Machines!B$5","v":0},{"$f":"Machines!B$7","v":0},{"$f":"Machines!B$18","v":0},{"$f":"Machines!B$24","v":0}]
[{"$f":"Machines!C$4","v":0},{"$f":"Machines!C$5","v":0},{"$f":"Machines!C$7","v":0},{"$f":"Machines!C$18","v":0},{"$f":"Machines!C$24","v":0}]
[{"$f":"Machines!D$4","v":0},{"$f":"Machines!D$5","v":0},{"$f":"Machines!D$7","v":0},{"$f":"Machines!D$18","v":0},{"$f":"Machines!D$24","v":0}]
[{"$f":"Machines!E$4","v":0},{"$f":"Machines!E$5","v":0},{"$f":"Machines!E$7","v":0},{"$f":"Machines!E$18","v":0},{"$f":"Machines!E$24","v":0}]
[{"$f":"Machines!F$4","v":0},{"$f":"Machines!F$5","v":0},{"$f":"Machines!F$7","v":0},{"$f":"Machines!F$18","v":0},{"$f":"Machines!F$24","v":0}]
[{"$f":"Machines!G$4","v":0},{"$f":"Machines!G$5","v":0},{"$f":"Machines!G$7","v":0},{"$f":"Machines!G$18","v":0},{"$f":"Machines!G$24","v":0}]
[{"$f":"Machines!H$4","v":0},{"$f":"Machines!H$5","v":0},{"$f":"Machines!H$7","v":0},{"$f":"Machines!H$18","v":0},{"$f":"Machines!H$24","v":0}]
[{"$f":"Machines2!B$4","v":0},{"$f":"Machines2!B$5","v":0},{"$f":"Machines2!B$7","v":0},{"$f":"Machines2!B$18","v":0},{"$f":"Machines2!B$24","v":0}]
[{"$f":"Machines2!C$4","v":0},{"$f":"Machines2!C$5","v":0},{"$f":"Machines2!C$7","v":0},{"$f":"Machines2!C$18","v":0},{"$f":"Machines2!C$24","v":0}]
[{"$f":"Machines2!D$4","v":0},{"$f":"Machines2!D$5","v":0},{"$f":"Machines2!D$7","v":0},{"$f":"Machines2!D$18","v":0},{"$f":"Machines2!D$24","v":0}]
[{"$f":"Machines2!E$4","v":0},{"$f":"Machines2!E$5","v":0},{"$f":"Machines2!E$7","v":0},{"$f":"Machines2!E$18","v":0},{"$f":"Machines2!E$24","v":0}]
[{"$f":"Machines2!F$4","v":0},{"$f":"Machines2!F$5","v":0},{"$f":"Machines2!F$7","v":0},{"$f":"Machines2!F$18","v":0},{"$f":"Machines2!F$24","v":0}]
[{"$f":"Machines2!G$4","v":0},{"$f":"Machines2!G$5","v":0},{"$f":"Machines2!G$7","v":0},{"$f":"Machines2!G$18","v":0},{"$f":"Machines2!G$24","v":0}]
[{"$f":"Machines2!H$4","v":0},{"$f":"Machines2!H$5","v":0},{"$f":"Machines2!H$7","v":0},{"$f":"Machines2!H$18","v":0},{"$f":"Machines2!H$24","v":0}]
[{"$f":"Machines3!B$4","v":0},{"$f":"Machines3!B$5","v":0},{"$f":"Machines3!B$7","v":0},{"$f":"Machines3!B$18","v":0},{"$f":"Machines3!B$24","v":0}]
[{"$f":"Machines3!C$4","v":0},{"$f":"Machines3!C$5","v":0},{"$f":"Machines3!C$7","v":0},{"$f":"Machines3!C$18","v":0},{"$f":"Machines3!C$24","v":0}]
[{"$f":"Machines3!D$4","v":0},{"$f":"Machines3!D$5","v":0},{"$f":"Machines3!D$7","v":0},{"$f":"Machines3!D$18","v":0},{"$f":"Machines3!D$24","v":0}]
[{"$f":"Machines3!F$4","v":0},{"$f":"Machines3!F$5","v":0},{"$f":"Machines3!F$7","v":0},{"$f":"Machines3!F$18","v":0},{"$f":"Machines3!F$24","v":0}]
[{"$f":"Machines3!G$4","v":0},{"$f":"Machines3!G$5","v":0},{"$f":"Machines3!G$7","v":0},{"$f":"Machines3!G$18","v":0},{"$f":"Machines3!G$24","v":0}]
[{"$f":"Machines3!H$4","v":0},{"$f":"Machines3!H$5","v":0},{"$f":"Machines3!H$7","v":0},{"$f":"Machines3!H$18","v":0},{"$f":"Machines3!H$24","v":0}]
[{"$f":"Machines4!B$4","v":0},{"$f":"Machines4!B$5","v":0},{"$f":"Machines4!B$7","v":0},{"$f":"Machines4!B$18","v":0},{"$f":"Machines4!B$24","v":0}]
[{"$f":"Machines4!C$4","v":0},{"$f":"Machines4!C$5","v":0},{"$f":"Machines4!C$7","v":0},{"$f":"Machines4!C$18","v":0},{"$f":"Machines4!C$24","v":0}]
[{"$f":"Machines4!D$4","v":0},{"$f":"Machines4!D$5","v":0},{"$f":"Machines4!D$7","v":0},{"$f":"Machines4!D$18","v":0},{"$f":"Machines4!D$24","v":0}]
[{"$f":"Machines4!F$4","v":0},{"$f":"Machines4!F$5","v":0},{"$f":"Machines4!F$7","v":0},{"$f":"Machines4!F$18","v":0},{"$f":"Machines4!F$24","v":0}]
[{"$f":"Machines4!G$4","v":0},{"$f":"Machines4!G$5","v":0},{"$f":"Machines4!G$7","v":0},{"$f":"Machines4!G$18","v":0},{"$f":"Machines4!G$24","v":0}]
[{"$f":"Machines4!H$4","v":0},{"$f":"Machines4!H$5","v":0},{"$f":"Machines4!H$7","v":0},{"$f":"Machines4!H$18","v":0},{"$f":"Machines4!H$24","v":0}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Maskiner, kr./ \"& VLOOKUP(Machines3!$J$22,Machines3!$J$23:$R$26,9)","v":"Maskiner, kr./ ton"},null,"Annual loss of value,%",{"$f":"Machines3!A18","v":"Tons/år i alt"},{"$f":"\"I alt omkostning, kr./\"& VLOOKUP(Machines3!$J$22,Machines3!$J$23:$R$26,9)","v":"I alt omkostning, kr./ton"}]
[{"$f":"Machines3!B$4","v":0},{"$f":"Machines3!B$5","v":0},{"$f":"Machines3!B$7","v":0},{"$f":"Machines3!B$18","v":0},{"$f":"Machines3!B$23","v":0}]
[{"$f":"Machines3!C$4","v":0},{"$f":"Machines3!C$5","v":0},{"$f":"Machines3!C$7","v":0},{"$f":"Machines3!C$18","v":0},{"$f":"Machines3!C$23","v":0}]
[{"$f":"Machines3!D$4","v":0},{"$f":"Machines3!D$5","v":0},{"$f":"Machines3!D$7","v":0},{"$f":"Machines3!D$30","v":0},{"$f":"Machines3!D$23","v":0}]
[{"$f":"\"Maskiner, kr./ \"& VLOOKUP(Machines3!$K$22,Machines3!$J$23:$R$26,9)","v":"Maskiner, kr./ ton"},null,"Annual loss of value,%",{"$f":"Machines3!E18","v":"Tons/år i alt"},{"$f":"\"I alt omkostning, kr./\" & VLOOKUP(Machines3!$K$22,Machines3!$J$23:$R$26,9)","v":"I alt omkostning, kr./ton"}]
[{"$f":"Machines3!F$4","v":0},{"$f":"Machines3!F$5","v":0},{"$f":"Machines3!F$7","v":0},{"$f":"Machines3!F$30","v":0},{"$f":"Machines3!F$22","v":0}]
[{"$f":"Machines3!G$4","v":0},{"$f":"Machines3!G$5","v":0},{"$f":"Machines3!G$7","v":0},{"$f":"Machines3!G$30","v":0},{"$f":"Machines3!G$22","v":0}]
[{"$f":"Machines3!H$4","v":0},{"$f":"Machines3!H$5","v":0},{"$f":"Machines3!H$7","v":0},{"$f":"Machines3!H$30","v":0},{"$f":"Machines3!H$22","v":0}]
[{"$f":"\"Vogne, kr./\" & VLOOKUP(Trailers!$J$20,Trailers!$J$21:$R$24,9)","v":"Vogne, kr./ton"},null,"Annual loss of value,%",{"$f":"Trailers!A18","v":"Tons/år i alt"},{"$f":"\"I alt omkostning, kr./\" & VLOOKUP(Trailers!$J$20,Trailers!$J$21:$R$24,9)","v":"I alt omkostning, kr./ton"}]
[{"$f":"Trailers!B$4","v":0},{"$f":"Trailers!B$5","v":0},{"$f":"Trailers!B$7","v":0},{"$f":"Trailers!B$18","v":0},{"$f":"Trailers!B$23","v":0}]
[{"$f":"Trailers!C$4","v":0},{"$f":"Trailers!C$5","v":0},{"$f":"Trailers!C$7","v":0},{"$f":"Trailers!C$18","v":0},{"$f":"Trailers!C$23","v":0}]
[{"$f":"Trailers!D$4","v":0},{"$f":"Trailers!D$5","v":0},{"$f":"Trailers!D$7","v":0},{"$f":"Trailers!D$18","v":0},{"$f":"Trailers!D$23","v":0}]
[{"$f":"\"Vogne, kr./\" & VLOOKUP(Trailers!K$20,Trailers!$J$21:$R$24,9)","v":"Vogne, kr./ton"},null,"Annual loss of value,%",{"$f":"Trailers!E18","v":"Tons/år i alt"},{"$f":"\"I alt omkostning, kr./\" & VLOOKUP(Trailers!K$20,Trailers!$J$21:$R$24,9)","v":"I alt omkostning, kr./ton"}]
[{"$f":"Trailers!F$4","v":0},{"$f":"Trailers!F$5","v":0},{"$f":"Trailers!F$7","v":0},{"$f":"Trailers!F$18","v":0},{"$f":"Trailers!F$23","v":0}]
[{"$f":"Trailers!G$4","v":0},{"$f":"Trailers!G$5","v":0},{"$f":"Trailers!G$7","v":0},{"$f":"Trailers!G$18","v":0},{"$f":"Trailers!G$23","v":0}]
[{"$f":"Trailers!H$4","v":0},{"$f":"Trailers!H$5","v":0},{"$f":"Trailers!H$7","v":0},{"$f":"Trailers!H$18","v":0},{"$f":"Trailers!H$23","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1234567891234,1234567891234,1234567891234,1234567891234,1234567891234]

{"sheet":"Guidance","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}